Skip to main content
Internet Archive's 25th Anniversary Logo

The FileMaker Report

The FileMaker Report: A Newsletter for FileMaker Users.


rss RSS

44
RESULTS


Show sorted alphabetically

Show sorted alphabetically

SHOW DETAILS
up-solid down-solid
eye
Title
Date Published
Creator
The FileMaker Report
by Elk Horn Publishing
texts

eye 33

favorite 0

comment 0

Issue 51 June 21, 1993 16 pages Feature: Database Publishing with FileMaker options direct from FileMaker indirect through a page layout program calculate formatting for output example Feature: Making POSTNET Bar Codes in FileMaker — saving postage calculating the barcode data printing Feature: Can a FileMaker Button Type Data into a Field - using the Paste Literal script command Quick Tips: New Stupid FileMaker Mistake Pro 2.0 v4 Password lookups Cancel Replace Paste ditto into Find request...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 37

favorite 0

comment 0

Issue 61 November 10, 1994 20 pages Feature: Conditional Branching in FileMaker Scripts — take advantage of the only script step that makes a decision Manipulate the record set to bend a script to the desired end Script examples Feature: Click 'n Type: Writing with a Mouse — report generation by assembling appropriate snippets of text Editing the snippets Techniques & Tips & Notes: Wholesale UK phone number conversion  Providing different messages in Browse and Preview modes...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 32

favorite 0

comment 0

Issue 48 December 21, 1992 16 pages Feature: Using QuicKeys"" with FileMaker — evolution of QuicKeys Mapping paging the book icon processing addresses data entry QuicKeys  wish list Note: CrimeBuster Update Feature: Counting Words with FileMaker accurate word count needed for classified ad application count spaces? Repeating field for entry with one word per line, however 'word' is defined the Count function counts lines of the repeating field words are exported, then imported into...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 27

favorite 0

comment 0

Issue 38 June 24, 1991 16 pages Feature: Automate Elimination of Duplicate Addresses — Number records within each group of dups Find all dups and delete all but one Feature: Catalog Publishing with FileMaker: Part 2 — Data-driven illustrations Adding emphasis Lookup graphics Update: Elapsed Time Corrections Q&A: Summarize Items From Repeating Fields — Extract line data, then summarize extracted information
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 35

favorite 0

comment 0

Resources: FileMaker consultants Feature: Preventing Fields from Sliding Up — using a 'stop-slide' field Feature: Weekend Date Calculations — knowing the day-of-week allows eliminating weekends from a span of dates Feature: Making Bar Graphs with FileMaker — put bars in picture fields look up the desired bars to construct a graph Feature: Addresses: Structures 8t Data — strategies for defining types of address files and for validating address data
Topics: FileMaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 33

favorite 0

comment 0

Issue 56 March 4, 1994 16 pages (incorrectly dated as March 4, 1993) Feature: Making FileMaker "External Functions" - scripting allows moving some functions outboard types of multi-file setups Put complex equations in separate files Tips on externalizing Feature: Another Number-to- Text Conversion — long calculation Uses a different and shorter technique than in issue 54 Explanation of technique Limited to positive values and numbers less than $999,999.99 commas ignored but allowed...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 34

favorite 0

comment 0

The FileMaker Report - Issue 11 April 7, 1988 Feature: Using FileMaker with MultiFinder Quick Tips: Tips from MacWorld Save large files as clone-plus-text Tips from MacUser Sorting with alphabetic/numeric data mixed in a field Merge files allow exporting field names as well as field data gaining screen space View Index in a calculated field in Find mode Double-click a View Index item to move it into a Find request Detecting erroneous letter 'O' in a numeric field Faking Found Set View Index...
Topics: FileMaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 24

favorite 0

comment 0

Issue 36 May 3, 1991 16 pages Feature: Record-to-Record Information Transfers — Looking up adjacent data to combine with local data Feature: A FileMaker Search-Only Field — Burying data in an unexpanded repeatingfield Feature: New Pro Serials (Better Than Oat Bran!) — Expanded serial numbers Mixed alpha and numeric serials Errors with numbers greater than 2111111111 Feature: Calculating Elaps'ed Times — New time functions Compute the difference between start time and stop time Feature:...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 37

favorite 0

comment 0

A Preview of New Features in FileMaker Pro 2.0
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 38

favorite 0

comment 0

Issue 60 September 20, 1994 16 pages Feature: Partial Unindexing in FileMaker — use numeric field for text data  What is indexing? Feature: Transferring Multiple Invoice Data to Checks — use an external macro to coordinate Make Repeats+ with FileMaker Feature: Guarding Serial Numbers & Reserializing Too Conflict between firmly fixed serial numbers and serializing imported records Instead of redefining the serial number back and forth, build custom protection that does not rely on...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Watertechnics
texts

eye 31

favorite 0

comment 0

Issue 65 September 1995 20 pages Waiting for ThreepointOh Database Design: A Five-Step Checklist Look for big problems Model the file structure Make basic design decisions Do it Test Addressing Address Files Resource Thinking about file architecture Addressing the problem How would a relational design work? Resources
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 39

favorite 0

comment 0

Issue 24 October 12, 1989 Update: Correction to 'Verbalizing Your Wealth' Feature: Printing Labels on a Laser Printer — details of label stock, layout design, good tips Feature: Tap the Power of Existing Data — Existing value only View Index Dummy records as 'bucket' for old data Self-lookup old data Monthly sets of repetitive checks Sets of order data Design Project: FileMaker Challenge
Topics: FileMaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 41

favorite 0

comment 0

Issue 16 November 15, 1988 - 16 Pages (Cover date printed incorrectly as October 15, 1988) Update: Correction for Last-Day-Of-Month calculation Feature: Aging Receivables — a simple approach Feature: Creating Serial Numbers for Existing Records — use a spreadsheet to generate serial numbers, then update records as they are imported Feature: Conditional Calculations — Equations that operate only on some records several examples Quick Tips: Update ImageWriter drivers Cursor keys will scroll...
Topics: Filemaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 27

favorite 0

comment 0

Issue 59 August 16, 1994  16 pages Feature: FileMaker Function Keys Unlimited — use QuicKeys and scripts to assign a different set of operations to keyboard function keys with every different layout Button design variations Feature: On-Line FileMaker Resources — AOL, eWorld Feature: Scripting Repeating Fields — moving data in an invoice file Use caution exercising such powerful scripts Create a custom warning message Feature: FileMaker Support at Claris — 12 sources
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 35

favorite 0

comment 0

Issue 34 January 30, 1991 16 Pages Feature: A Project Management Information System Set of interlocking files to handle a variety of needs for small consulting firms. Prospects, Clients, Proposals, Contracts, Employees, WIP, Invoices, Ledger Feature: Locating Ignored Characters — Get characters not indexed Use Position function for special searches Can be a reasonably general technique
Topics: FileMaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 26

favorite 0

comment 0

Issue 57 April 28, 1994 16 pages Feature: Cross-Platform FileMaker — not exactly the same on both but quite close DOS naming conventions font adjustments performance minor issues Feature: Mixing Platforms with FileMaker  — several operating and performance difficulties Q&A: Move Separate Data into Repeating Fields — scripting a sequence of cut and paste operations Quick Tips: Don't Print and Calculate at the same time Another way to calculate date suffixes Put cosmetic return...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 33

favorite 0

comment 0

Issue 50 April 12, 1993 16 pages Feature: Stupid FileMaker Mistakes ("Don't Do That!") - Things to not do in FileMaker Q&A: Calculating the Latest of Three Dates — use a repeating field for the dates and then compute the max date step-by-step  accumulation of an equation for dates in separate fields Feature: A Birthday and Anniversary Reminder System — calculate ages and  years married countdown equations Quick Tips: Parity for checking repeating field sequence numbers...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 28

favorite 0

comment 0

Issue 43 March 6, 1992 16 pages Feature: Questionnaire Response Percentages (Using the Summary Function) Feature: Putting Commas in Addresses Seven methods for dealing with commas between City and State in an address Equation du Jour: Monitoring ZIP Codes Several equations for checking the validity of ZIP codes Tests combined into one calculation Feature: Networking With FileMaker Accessing FileMaker files on a different machine across a network Problems Limitations Feature: Remote Printing...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 24

favorite 0

comment 0

Issue 35 March 7, 1991 16 pages Feature: Add-on and Push-down Data Stacks Manipulating repeating fields to add-on or push-down new data Repeating field sequence numbers Looking-up sequence numbers for new records variations Q&A: Finds in Repeating Fields Extract data buried in a repeating field then use it find desired information Equation du Jour: Group Sequence Numbers — Numbering record groups
Topics: FileMaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 37

favorite 0

comment 0

Issue 46 August 31, 1992 20 pages Feature: Making Use of FileMaker Value Lists Creating the list Editing the list Field Format command selects type of list display: pop-ups, check boxes, menus, radio buttons Data entry variations with list type Note: Using Radio Buttons in Find Screens Feature: Transportation Dispatching Template Tracking vehicles, expenses, and drivers management reports Q&A: Summary Reports from Repeating Fields Split repeating fields into another file to use for reports...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 37

favorite 0

comment 0

Issue 37 June 14, 1991 16 pages Feature: Catalog Publishing with FileMaker: Part 1 — Use data-driven layouts Tricky layouts Mirroring alternate pages Gutters Calculating page locations Q&A: Finding Not-recent Customers — Characteristics of groups of records Find by customer and put latest date in all Feature: Using Calculation and Data Fields Together — Putting the cursor in a calculated field Auto fill-in of Bill-To/Ship-To fields An IF override Hide data fields from some users
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 30

favorite 0

comment 0

Sequential Index to Issues 21 through 61 Version 1 of the newsletter spanned issues 1 through 35.  News & Notesand Resources columns in version 1 are not indexed here. Version 2 spanned issues 36 through 60. Version 3 started at issue 61. Newsletter version changes represent significant format updates.
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 31

favorite 0

comment 0

Issue 62 December 12, 1994 12 Pages Features: Using the FileMaker RANDOM Function Converting Integer Fractions to Decimal Fractions FileMaker Tips, Techniques & Notes: Show Clipboard The Dog Ate My Homework Find More, Find Fewer Nomenclature Technical FileMaker Database Previewing the Current Record Screen Sizes Part Label Actions
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 35

favorite 0

comment 0

Issue 44 April 22, 1992 16 pages Feature: CrimeBuster: FileMaker in the Streets Using FileMaker to fill out police crime reports A PowerBook in the field Navigation problems Printing complex and variable-length reports FileMaker as a custom development tool Feature: Anatomy of CrimeBuster Design Design history Floating button bar FileMaker as a consulting tool Feature: Capitalizing States (Un) Properly The Proper function: limitations and cautions State abbreviations should not be...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 51

favorite 0

comment 0

Sequential Index to Issues 1 through 54 Each issue through 35 included a table of contents on page 1, copyright notices on page 2, and subscription details on the back cover.  The format changed with issue 36 with most overhead text moved to the back cover and a feature article beginning on page 1.  The new format carries about 40% more information in the same number of pages.  Many issues before 36 contained News & Notes and Resources columns that are not indexed here.
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 28

favorite 0

comment 0

Issue 58 June 21, 1994 16 pages Feature: Checking Checked Check Boxes — many responses from subscribers What are value lists and check-box fields? An easy way to view check box experiments Use field length equation for fixed-length values Sequence of checks Variable length items Faking fixed-length Locate returns inserted by FileMaker Change the groundrules Decode presence of specific values Use Sum where it was not intended for a simple solution Feature: Creating Even Multiple Columns —...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 25

favorite 0

comment 0

Issue 55 December 30, 1993 16 pages Feature: Using External Scripts, Automating Inventory Updates — how to make a script in one file talk to another file Using this capability to update an inventory file Feature: Skipping Labels on Laser Printer Label Stock aset of scripts and a special layout that allows use of partial pages of labels Feature: Extracting ZIP and State development of an equation to pull out two pieces of information from a combined field Quick Tips: FileMaker as a Graphics...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 32

favorite 0

comment 0

Issue 64 April 10, 1995 16 pages Feature: A Little FileMaker Magic Finding the Mayor's Husband Three, Three, Three Forms in One Through the Looking-Up Glass Q & A:  Scripting to the Next Available Repeating Line Feature: A Big White Box for the Page Break Blues Hello! & Moving On
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 25

favorite 0

comment 0

Issue 63 February 6, 1995 16 pages Feature: Segmenting FileMaker Scripts Q&A:  Making Custom Radio Buttons Eliminating Weekend Dates Equation du Jour Review:  At Last, A Good FileMaker Book FileMaker Tips, Techniques, & Notes
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 35

favorite 0

comment 0

Issue 49 March 3, 1993 16 pages Feature: Expanded Lookups: Overwrites & Aliases Copying empty lookup data aliases of lookups work remote aliases Feature: Calculating Date Suffixes — put 'nd' in '2nd' Added automation for data entry Those tough teens: 1st, 2nd, 3rd, 4th Custom date formatting Feature: Calculating Fonts and Font Style Cannot directly compute a font or style.  Workaround: stacking mutually-exclusive fields Feature: Viewing the Index of the Found Set Simply calculate a new...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 42

favorite 0

comment 0

Issue 40 September 18, 1991 16 pages Feature: FileMaker Pro Security Features Control over Activities (with passwords) and Resources(with groups) Overview dialog Group and password associations with layouts and fields Bonus: seeing which fields are on a given layout and which layouts use a given field Q&A: Add and Update Records at the Same Time — Six approaches Feature: DBF Format Reveals Max Length of Field Data Details about the DBF import/export format Quick Tips: Claris fax service...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 32

favorite 0

comment 0

Issue 41 November 8, 1991 16 pages Feature: A FileMaker Correspondence File Handling notes, memos, faxes, letters in one FileMaker file  Calculations allow easy customization Different layouts for different tasks Accumulated database of all correspondence Feature: Hunting the Elusive Field Using Security overview to locate occurrence of fields on layouts Feature: FileMaker Button Tips and Tricks — Any object a button Don't overuse Be consistent Good design Resolution of button graphics Help...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 34

favorite 0

comment 0

Issue 39 August 9, 1991 16 pages Feature: Power Pop-Ups — A value list with 1100 entries Organizing the values Time to pop-up Efficient data entry Update: Errata: Telephone Number Formatting Feature: Counting the Number of Unique Entries Feature: Adding and Updating Record Numbers — Two techniques to revise existing or add new serial numbers In Pro use the new Summary (running count) function to auto-generate serial numbers. Create within FileMaker a set of serials starting with any value...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 30

favorite 0

comment 0

Issue 53 March 3, 1993 16 pages Feature: Working with Multimedia in FileMaker CrimeWriter for training police recruits combining still pictures, audio, video, in FileMaker on a PowerBook difficulties encountered navigation tips and tricks minimizing storage space Feature: Making Complex Equations Easier to Read  Add return characters freely to equations for line arrangement Quick Tips: More on accidental deletions Another Stupid FileMaker Mistake Transporting address files Eliminate redundant...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 28

favorite 0

comment 0

Issue 52 August 16, 1993 16 pages Feature: Importing Fixed-Field-Length Addresses —non-DBF files need calculations to extract field data by position trim Feature: Extracting First and Last Names from Full Names understanding Full Name format is essential complicating factors nesting Position functions Feature: Structured Development of FileMaker Solutions use a FileMaker file to keep a database of fields and field characteristics of other files cattle herd management example synchronizing...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 25

favorite 0

comment 0

Issue 47 October 15, 1992 16 pages Feature: Recovering FileMaker Databases —autorepair and recover operations typical error messages Recovery steps described Locking prevention Note: Fixing Files — tips and observations Feature: Augmenting Value List Functionality more tips: selecting multiple values, deselecting values Feature: Displaying Calculated Blanks — not displaying a null result as a zero TextToNum helps examples Feature: Latest-Record Lookups FileMaker looks up from the first...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 25

favorite 0

comment 0

Issue 32 October 18, 1990 16 Pages Equation du Jour: Calculating Volume Discounts Entering a price on an order that varies with the quantity ordered Calculated and looked-up Based on total order volume Q&A: Calculating with Summary Fields Browse summaries, export summaries, graph summaries Feature: Managing Checking Accounts — Entering transactions Printing checks Text version of numeric amount Assigning check numbers Allocating to accounts Balancing Reconciling with bank Handling errors...
Topics: FileMaker, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 38

favorite 0

comment 0

Issue 54 November 10, 1993 16 pages Feature: Calculate Word Equivalents of Numbers — a very long equation that converts numeric values into words Feature: Find-and-Replace Calculations in FileMaker — a complex series of equations for multiple    find/replace operations on data fields Feature: Custom Rounding Calculations — decoding the Round function building custom rounding examples
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Watertechnics
texts

eye 29

favorite 0

comment 0

Issue 67 October 1996 ThreePointOh, We Hardly Know Ye (Part 1) Where Are We? Detecting Out-of-Place Characters News & Notes 3.0 For Windows Server 3.0 v2 3.0 SDK Tango CSA
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 24

favorite 0

comment 0

Issue 29 June 28, 1990  16 pages Feature: Exploring FileMaker Pro — Naming layouts Sizing Pop-up layout list Six pre-formatted layouts Passwords and Groups Feature: Locating Customers who have not recently ordered. very tough in a file with one record per order  Selective self- lookups Update records with cross-data Feature: New Uses for Repeating Fields — Enhancing Finds Manual indexing Flexible addressing  Address fi!tering.
Topics: FileMaker, Newsletter
The FileMaker Report
by Watertechnics
texts

eye 30

favorite 0

comment 0

Issue 66 April 1996 16 Pages ThreePointOh, The Big Picture Some Thoughts on Windows 95 FileMaker 3.0, When and How A little FileMaker History Tips and Tricks 3.0 Undocumented Features Layout Part Fills Field Backgrounds ASCII Language Choice Word/Phrase Indexing Early Reactions to 3.0
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 25

favorite 0

comment 0

Issue 45 June 16, 1992 16 pages Feature: Reorganizing a Subscription Database ("What is a Filet") Ask the right questions Evolving file structure What is a record! Checking basic premises Report calculations Feature: Selective Relookups For New Fields — Two approaches Feature: Tracking Project Contacts: Who Said What to Whom and Whent — Simple template for managing a manager's contacts and commitments with both subordinates and bosses Flags when mis-entries are detected Quick...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Elk Horn Publishing
texts

eye 40

favorite 0

comment 0

Issue 42 December 18, 1991 16 pages Feature: A Guide to FileMaker Lookups The lookup process Network lookups Defining a lookup Data movement Multiple lookup files Lookup failure options Lookup keys Smaller 'cusp' lookup tables Self lookups Example Follow-up: Correspondence Files Equation du Jour: Calculating Date Quarters Many date/time related functions built-in, but not quarters Several ways to calculate Feature: Speeding Import/Export in FileMaker Pro Import/export process changes in Pro...
Topics: FileMaker, Claris, Database, Newsletter
The FileMaker Report
by Watertechnic
texts

eye 39

favorite 0

comment 0

Issue 68 April 1997 16 pages Calendar Navigation in FileMaker Pro ThreePointOh, We Hardly Know Ye (part 2) A Universal Back Button The FileMaker Bowl
Topics: FileMaker, Claris, Database, Newsletter